HOME

Enter subhead content here

Experience Summary :
Extensive experience of about eight years in software design, development, testing and implementation in Client-Server large mission critical on-line environment. Proficiency in:

Personnel Details:
 
 

Date Of Birth	6th February, 1971
Current Employer	SUN Microsystems, USA.
Professional Experience	Jan 1994 - July 1997 (CMC Limited, India) July 1997 - July 2000 (BRI Inc., USA - A subsidiary of CMC Ltd)
Contact Email-id	mahato@hotmail.com
Contact Phone #s	1-978-458-4839, 1-978-828-0669

Project Experience:

ASM-GOALING Project
Since April 1999
SUN Microsystems, Chelmsford (Boston) , MA

This project is currently under development using lot of Unix shell scripts, Java programs and stored procedures in Oracle and Sybase. BRIO software would be used as a reporting tool. When completed, this would capture and effeciently validate the data coming through new and existing Contracts throughout the year. At the end of the fiscal year this data along with the data from other systems would be merged and help in preparing Goals for the Sales Managers for the next fiscal year. Once installated, the time taken for the GOALING process would be reduced to 1 month, compared to the 5 months, which is done manually.
 
 

Environment	Solaris
Hardware	SUN E-450, Ultra-60
Application Software	CGI, Perl, Oracle, BRIO

 
Datawarehousing Project
Jan 1999
T Rowe Price, Baltimore, Maryland

Work mainly involved conversion of reports and universe from Business Objects ver 3.1 to ver 4.11. Also involved in the installation and training also. Provided consultancy on the security issues involved because of the high volume of users (approx. 300).
 

Environment	Solaris, NT
Application Software	Business Objects 4.x, Sybase 11.x

Datawarehousing Project
Dec 1998
3COM, Santa Clara, California

Work mainly involved designing of the datawarehouse and preparation of the universes in Business Objects, to ultimately take over the existing universe, which has gone outdated with time and requirements. The reports were created using Business Objects Web-Intelligence and BO 4.x, so that those can be distributed over the intranet. Also did the system study to identify the drawbacks in the current system and suggested ways to get rid of those, thereby developing a datawarehouse that eliminates those drawbacks.
 

Environment	Windows 95, NT
Application Software	Business Objects 4.x, BO Web-intelligence, Oracle 7.3

Datawarehousing Project
Nov 1998
Schering Plough, New Jersey.

Actively got involved in this week long assignment to do a system study on their existing system and network, and suggest proper tools and ways to go around in re-designing the datawarehouse.
 

Environment	Windows 95, NT
Application Software	Business Objects 4.x, BO Web-intelligence, Oracle 7.3

Project on datawarehousing.
May 1998 - September 98
 SUN Microsystems (USA), Milpitas, California.
 
Work mainly involves preparation of universe and reports using Business Objects for analysing the contracts and warranties. It also prepares overview on total sales and helps in deciding the commissions to be given to the agents. Some of these reports are also published on the SUN's internal website - every week-end, month-end and fiscal-month-end.

 Responsibility:-
Y Developing and modifying universes and reports in Business Objects & queries.
Y Providing Consultancy to users
YMaintaining reports on SUN's internal web-site
YWriting of Unix shell scripts to automate the process of running, generating and publishing reports.
 

Hardware	Sun Sparc 5
Environment	Solaris
Application Software	Business Objects, Oracle 7.3

Project on datawarehousing.
Jan 1998 - May 1998
 Coherent Technologies (US), Santa Clara, California.
 
The work involved movement of old data from MANMAN system to Oracle. Apart from just movement, data needed polishing to fit in to the new requirements of the users. Work also required modification of the existing datawarehouses or designing of new ones, as well as conversion of old forms into Oracle WebForms so that users can use through the net. A project involving pulling up of data from excel sheets and loading on the Oracle Database was also completed using Visual Basic.
 

Responsibility:-
YDeveloping and modifying universes and reports in Business Objects & queries.
Y Creation of users, and granting of groups and roles.
Y Installation and setup of the softwares.
Y Providing Consultancy to users
 

Hardware	Intel based machines
Environment	Windows NT and 95
Application Software	Business Objects 4.x and 4.0x, Oracle 7.1, Visual Basic 4.x

DISTI- Distribution, Sales and Planning.
August 1997 - Oct 1997
 WYSE Technology (US), San Jose, California.
 
DISTI Application has been designed to record, analyze and forecast the revenue and sales of different WYSE products. Inventory information data is collected from the distributors (domestic and international) on a monthly basis. This data is used to compute flow-through i.e. quantity of products sold by distributors to customers in a given time frame. This requires accurate and informative reports, to provide the ability to make sound business decisions such as sales forecasting and planning decision. The reports generated were not only meant for USA but also for Taiwan.
 
Responsibility:-
YDeveloping and modifying reports application in Business Objects thus providing the user with easy & quick access to database through reports & queries.
Y Creation of users, groups and roles.
Y Installation and setup of the software.
Y Providing Consultancy to users in USA and Taiwan
 

Hardware	Intel based machines
Environment	Windows NT and 95
Application Software	Business Objects 4.x and 4.0x, Oracle 7.1

INTEGRATED CARGO MANAGEMENT SYSTEM (ICMS)
 Jan 1994 - Jul 1997
 Airports Authority Of India (AAI) IGI Airport, New Delhi

 ICMS provides facilities for management of cargo for Import, Export, Transshipment and Disposal. In addition to cargo operations, it provides functionality for the associated Accounts & Billing and Warehouse & Inventory Management. The system incorporates client-server architecture, distributed relational databases and graphical user interface capabilities. The entire operation is handled by around 120 transactions from over 100 on-line terminals located in the cargo complex across a radius of 2 Km. It has got EDI connectivity with the Customs and remote connectivity with the Agents and Airlines. The system recently incorporated the facility of generation, identification and tracking of consignments with the help of bar-codes.

 Responsibilities
YPreparation of MMI screens for Import, Export and Disposal Modules in SYBASE APT
YPreparation of SRS of the Project using Case tool (Turbo Analyst 2.20)
YWriting of Program Specifications and Coding of functions using SYBASE SQLserver, APT Preparation of Reports using SYBASE Report Workbench and GUPTA Report Windows
YSystem Administration activities
YIntegration and testing
YUnit testing
YAcceptance Testing
YTrouble shooting
YPerformance monitoring and tuning
YPreparation of proposals
YCorrespondence with the customers
 

Hardware	Two HP H50 in a hot standby mode as servers  Four E45 and PC s as clients
Environment	HP-UX 10.x, MS-DOS, MS-Windows for WorkGroups,  Pathways Access (3.0)
Software	SYBASE 10.0.1, GUPTA SQLwindows 5.0.1

Project      : MATERIAL MANAGEMENT SYSTEM  (MMS)
May 1995 - Aug 1995
 Department of Posts,  India
 
Material Management System for the Department of Posts covers all the functions relating to Procurement, Stock Maintenance, Budgeting, Day to day activities, etc. Timely generation of invoices, bid evaluation consultancy and prior information regarding the stock deficits were some of the focus areas. Currently it caters to around 70 different locations all over India.

 Responsibilities:
YInstallation at new locations
YSystem software support
YModification, testing and implementation
YSoftware maintenance
YCustomer training
 

Hardware	PC 386
Environment	SCO-UNIX,
Software	Foxbase Plus

 Project     :   PERSONNEL INFORMATION SYSTEM  (PIS)
Oct 1993 -Nov1993
 CMC Limited, Calcutta, India
 
Personnel Information System developed for CMC Ltd., Calcutta, involves all the operations dealing with the day-to-day, monthly and yearly activities of the employees. It provides vital information like the daily attendance, monitoring of employees on duty out at customer locations, generation of personnel activities reports etc.
 
Responsibilities:
YSystem Analysis and Design, Preparation of SRS  using Case tool (Turbo Analyst 2.20)
YPreparation of MMI screens in INGRES
YWriting of Program Specifications
YCoding of functions using INGRES
YPreparation of reports using INGRES ReportWorkbench
YIntegration and testing
YSystem Administration activities
 

Hardware	PC 386
Software	INGRES 5.0
Environment	SCO-UNIX

 Professional Courses/Trainings Attended:
 

TITLE	SUBJECT	ORGANISATION	PERIOD
under GRADUATE COURSE in COMPUTER SCIENCE from rec rourkela(PGCACS)	Computer Organisation, Data Structures,  UNIX, Pascal, C, Assembly, RDBMS-Ingres, Lotus, OOP and CICS.	REC ROURKELA, India	JUL 89 to MAY 93.
GUPTA SQL Windows 4.0	GUPTA 4.0	IIS Infotech, New Delhi, India	May 1994   (2 weeks)
GUPTA SQL Windows 5.0	GUPTA 5.0	-do-	Mar 1995  (2 weeks)
OOP using Visual C++	Visual C++ 2.0	STG, New Delhi	May 1996  (1 week)
Application Testing Procedures	Application Integration and testing	CMC Ltd., New Delhi	Nov 1996  (1 week)
Interweave Information System, ver-1.0	Datawarehouse concepts, Development of reports and queries.	Interweave, San Jose, California, USA	July 1997 (1 week)
BRIO Basics	BRIO designer	BRIO Technology, Mtn View, California, USA	January 1999 (1 day)
Advanced course on BRIO designer	BRIO Designer and Administrator	SUN Microsystems, Milpitas, California, USA	August 1999 (3 days)

Awards and Appreciations:
YSpecial appreciation award for development and implementation of ICMS for AAI.

References

1. Karen Brandao
    3COM, Santa Clara, CA
   408-2255991

2. Mukesh Advani
   WYSE Technology, Santa Clara, CA
   408-4732025

3. DR.S.K RATH
   PROF.&HEAD CSE DEPTT. REC ROURKELA
   408-7644316

4. Jon Yuan
   T Rowe Price, Baltimore, MD
   410-3458637

5. Kathy Bedell
   SUN Microsystems, Boston, USA
  781-442-0564

6. Beth Diggle-Johnson
    SUN Microsystems, Palo Alto, CA
 
 
 

Enter content here